external data reconciliation